Setting Foreign Key Properties

Use the Constraint Name edit box to enter a name for the new key.

Use the Reference Schema, Reference Table and Reference Constraint dropdown lists to select a foreign schema, table and constraint respectively.

To include field(s) to the key, click to open the editor(s) for editing under Local Field Names.

The On Delete dropdown list defines the type of the actions to be taken.

No Action (default)
Referenced key values will not be updated or deleted.

Cascade
Delete any rows referencing the deleted row, or update the value of the referencing column to the new value of the referenced column, respectively.

Set Null
Set the referencing column(s) to null.

Enable
You can choose whether to enable / disable the foreign key constraint by checking / unchecking the box.